Profiling Report

Dataset statistics

Number of variables	36
Number of observations	193
Missing cells	2453
Missing cells (%)	35.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	54.4 KiB
Average record size in memory	288.7 B

Variable types

Text	2
Categorical	8
Numeric	15
Unsupported	10
DateTime	1

Alerts

`Qty owned used` has constant value ""	Constant
`Qty wanted` has constant value ""	Constant
`Priority` has constant value ""	Constant
`Qty owned` is highly imbalanced (89.6%)	Imbalance
`Qty owned new` is highly imbalanced (89.6%)	Imbalance
`Subtheme` has 18 (9.3%) missing values	Missing
`Minifigs` has 15 (7.8%) missing values	Missing
`Pieces` has 3 (1.6%) missing values	Missing
`RRP (GBP)` has 10 (5.2%) missing values	Missing
`RRP (USD)` has 12 (6.2%) missing values	Missing
`RRP (CAD)` has 102 (52.8%) missing values	Missing
`RRP (EUR)` has 154 (79.8%) missing values	Missing
`EAN` has 39 (20.2%) missing values	Missing
`UPC` has 25 (13.0%) missing values	Missing
`Width` has 9 (4.7%) missing values	Missing
`Height` has 9 (4.7%) missing values	Missing
`Depth` has 9 (4.7%) missing values	Missing
`Weight` has 73 (37.8%) missing values	Missing
`Notes` has 193 (100.0%) missing values	Missing
`Wanted` has 193 (100.0%) missing values	Missing
`Flag 1 not used` has 193 (100.0%) missing values	Missing
`Flag 2 not used` has 193 (100.0%) missing values	Missing
`Flag 3 not used` has 193 (100.0%) missing values	Missing
`Flag 4 not used` has 193 (100.0%) missing values	Missing
`Flag 5 not used` has 193 (100.0%) missing values	Missing
`Flag 6 not used` has 193 (100.0%) missing values	Missing
`Flag 7 not used` has 193 (100.0%) missing values	Missing
`Flag 8 not used` has 193 (100.0%) missing values	Missing
`Value new (USD)` has 2 (1.0%) missing values	Missing
`Value used (USD)` has 9 (4.7%) missing values	Missing
`Launch date` has 17 (8.8%) missing values	Missing
`Exit date` has 17 (8.8%) missing values	Missing
`Number` has unique values	Unique
`Notes` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Wanted` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Flag 1 not used` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Flag 2 not used` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Flag 3 not used` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Flag 4 not used` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Flag 5 not used` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Flag 6 not used` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Flag 7 not used` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Flag 8 not used` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2024-02-07 23:09:24.842671
Analysis finished	2024-02-07 23:09:58.157899
Duration	33.32 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

Number
Text

UNIQUE

Distinct	193
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.6 KiB

Length

Max length	9
Median length	6
Mean length	6.2797927
Min length	6

Characters and Unicode

Total characters	1212
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	193 ?
Unique (%)	100.0%

Sample

1st row	3569-1
2nd row	3825-1
3rd row	4191-1
4th row	4476-1
5th row	4722-1

Value	Count	Frequency (%)
3569-1	1	0.5%
3825-1	1	0.5%
4855-1	1	0.5%
4191-1	1	0.5%
4476-1	1	0.5%
4722-1	1	0.5%
4754-1	1	0.5%
4757-1	1	0.5%
4758-1	1	0.5%
4762-1	1	0.5%
Other values (183)	183	94.8%

Most occurring characters

Value	Count	Frequency (%)
1	253	20.9%
-	193	15.9%
7	188	15.5%
9	90	7.4%
6	87	7.2%
5	81	6.7%
3	69	5.7%
0	68	5.6%
2	64	5.3%
8	63	5.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1019	84.1%
Dash Punctuation	193	15.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	253	24.8%
7	188	18.4%
9	90	8.8%
6	87	8.5%
5	81	7.9%
3	69	6.8%
0	68	6.7%
2	64	6.3%
8	63	6.2%
4	56	5.5%

Dash Punctuation

Value	Count	Frequency (%)
-	193	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1212	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	253	20.9%
-	193	15.9%
7	188	15.5%
9	90	7.4%
6	87	7.2%
5	81	6.7%
3	69	5.7%
0	68	5.6%
2	64	5.3%
8	63	5.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1212	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	253	20.9%
-	193	15.9%
7	188	15.5%
9	90	7.4%
6	87	7.2%
5	81	6.7%
3	69	5.7%
0	68	5.6%
2	64	5.3%
8	63	5.2%

Theme
Categorical

Distinct	23
Distinct (%)	11.9%
Missing	0
Missing (%)	0.0%
Memory size	1.6 KiB

Star Wars	114
City	16
Castle	13
Harry Potter	7
Marvel Super Heroes	6
Other values (18)	37

Length

Max length	24
Median length	9
Mean length	9.0310881
Min length	4

Characters and Unicode

Total characters	1743
Distinct characters	40
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	5.2%

Sample

1st row	Sports
2nd row	SpongeBob SquarePants
3rd row	Pirates of the Caribbean
4th row	Star Wars
5th row	Harry Potter

Common Values

Value	Count	Frequency (%)
Star Wars	114	59.1%
City	16	8.3%
Castle	13	6.7%
Harry Potter	7	3.6%
Marvel Super Heroes	6	3.1%
Indiana Jones	6	3.1%
Atlantis	5	2.6%
Aqua Raiders	3	1.6%
Super Mario	3	1.6%
Dino 2010	3	1.6%
Other values (13)	17	8.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
star	114	32.9%
wars	114	32.9%
city	16	4.6%
castle	13	3.8%
super	9	2.6%
harry	7	2.0%
potter	7	2.0%
marvel	6	1.7%
heroes	6	1.7%
indiana	6	1.7%
Other values (25)	48	13.9%

Most occurring characters

Value	Count	Frequency (%)
a	297	17.0%
r	285	16.4%
t	178	10.2%
s	156	9.0%
	153	8.8%
S	130	7.5%
W	114	6.5%
e	73	4.2%
i	47	2.7%
n	39	2.2%
Other values (30)	271	15.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1231	70.6%
Uppercase Letter	345	19.8%
Space Separator	153	8.8%
Decimal Number	12	0.7%
Dash Punctuation	2	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	297	24.1%
r	285	23.2%
t	178	14.5%
s	156	12.7%
e	73	5.9%
i	47	3.8%
n	39	3.2%
o	32	2.6%
l	28	2.3%
y	23	1.9%
Other values (12)	73	5.9%

Uppercase Letter

Value	Count	Frequency (%)
S	130	37.7%
W	114	33.0%
C	31	9.0%
H	13	3.8%
M	12	3.5%
A	10	2.9%
P	9	2.6%
I	7	2.0%
J	6	1.7%
B	5	1.4%
Other values (3)	8	2.3%

Decimal Number

Value	Count	Frequency (%)
0	6	50.0%
1	3	25.0%
2	3	25.0%

Space Separator

Value	Count	Frequency (%)
	153	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1576	90.4%
Common	167	9.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	297	18.8%
r	285	18.1%
t	178	11.3%
s	156	9.9%
S	130	8.2%
W	114	7.2%
e	73	4.6%
i	47	3.0%
n	39	2.5%
o	32	2.0%
Other values (25)	225	14.3%

Common

Value	Count	Frequency (%)
	153	91.6%
0	6	3.6%
1	3	1.8%
2	3	1.8%
-	2	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1743	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	297	17.0%
r	285	16.4%
t	178	10.2%
s	156	9.0%
	153	8.8%
S	130	7.5%
W	114	6.5%
e	73	4.2%
i	47	2.7%
n	39	2.2%
Other values (30)	271	15.5%

Subtheme
Categorical

MISSING

Distinct	50
Distinct (%)	28.6%
Missing	18
Missing (%)	9.3%
Memory size	1.6 KiB

The Clone Wars	35
Episode III	15
Episode VI	11
Episode V	10
Episode IV	9
Other values (45)	95

Length

Max length	30
Median length	25
Mean length	12.605714
Min length	4

Characters and Unicode

Total characters	2206
Distinct characters	53
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	20 ?
Unique (%)	11.4%

Sample

1st row	Football
2nd row	On Stranger Tides
3rd row	Episode VI
4th row	Philosopher's Stone
5th row	Prisoner of Azkaban

Common Values

Value	Count	Frequency (%)
The Clone Wars	35	18.1%
Episode III	15	7.8%
Episode VI	11	5.7%
Episode V	10	5.2%
Episode IV	9	4.7%
Fantasy Era	8	4.1%
Episode I	5	2.6%
The Mandalorian	4	2.1%
Miscellaneous	4	2.1%
Promotional	4	2.1%
Other values (40)	70	36.3%
(Missing)	18	9.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
episode	52	13.2%
the	45	11.4%
wars	35	8.9%
clone	35	8.9%
iii	15	3.8%
of	12	3.0%
vi	11	2.8%
v	10	2.5%
iv	9	2.3%
fantasy	8	2.0%
Other values (75)	162	41.1%

Most occurring characters

Value	Count	Frequency (%)
e	221	10.0%
	219	9.9%
o	185	8.4%
a	148	6.7%
s	146	6.6%
i	125	5.7%
r	118	5.3%
n	105	4.8%
l	103	4.7%
I	78	3.5%
Other values (43)	758	34.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1546	70.1%
Uppercase Letter	425	19.3%
Space Separator	219	9.9%
Decimal Number	7	0.3%
Other Punctuation	5	0.2%
Dash Punctuation	4	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	221	14.3%
o	185	12.0%
a	148	9.6%
s	146	9.4%
i	125	8.1%
r	118	7.6%
n	105	6.8%
l	103	6.7%
d	76	4.9%
t	76	4.9%
Other values (14)	243	15.7%

Uppercase Letter

Value	Count	Frequency (%)
I	78	18.4%
E	62	14.6%
C	55	12.9%
T	44	10.4%
W	35	8.2%
V	31	7.3%
S	21	4.9%
M	18	4.2%
P	16	3.8%
F	15	3.5%
Other values (10)	50	11.8%

Decimal Number

Value	Count	Frequency (%)
2	4	57.1%
4	1	14.3%
5	1	14.3%
3	1	14.3%

Other Punctuation

Value	Count	Frequency (%)
'	3	60.0%
.	1	20.0%
:	1	20.0%

Space Separator

Value	Count	Frequency (%)
	219	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1971	89.3%
Common	235	10.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	221	11.2%
o	185	9.4%
a	148	7.5%
s	146	7.4%
i	125	6.3%
r	118	6.0%
n	105	5.3%
l	103	5.2%
I	78	4.0%
d	76	3.9%
Other values (34)	666	33.8%

Common

Value	Count	Frequency (%)
	219	93.2%
-	4	1.7%
2	4	1.7%
'	3	1.3%
4	1	0.4%
5	1	0.4%
3	1	0.4%
.	1	0.4%
:	1	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2206	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	221	10.0%
	219	9.9%
o	185	8.4%
a	148	6.7%
s	146	6.6%
i	125	5.7%
r	118	5.3%
n	105	4.8%
l	103	4.7%
I	78	3.5%
Other values (43)	758	34.4%

Year
Real number (ℝ)

Distinct	18
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2011.1554

Minimum	2001
Maximum	2024
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	2001
5-th percentile	2004
Q1	2007
median	2009
Q3	2012
95-th percentile	2023
Maximum	2024
Range	23
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	6.4361191
Coefficient of variation (CV)	0.0032002097
Kurtosis	-0.61599986
Mean	2011.1554
Median Absolute Deviation (MAD)	3
Skewness	0.88969784
Sum	388153
Variance	41.423629
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
2008	24	12.4%
2007	20	10.4%
2006	18	9.3%
2009	18	9.3%
2011	16	8.3%
2023	16	8.3%
2022	16	8.3%
2005	14	7.3%
2010	14	7.3%
2012	11	5.7%
Other values (8)	26	13.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2001	1	0.5%
2002	3	1.6%
2003	2	1.0%
2004	7	3.6%
2005	14	7.3%
2006	18	9.3%
2007	20	10.4%
2008	24	12.4%
2009	18	9.3%
2010	14	7.3%

Value	Count	Frequency (%)
2024	2	1.0%
2023	16	8.3%
2022	16	8.3%
2021	7	3.6%
2020	3	1.6%
2017	1	0.5%
2012	11	5.7%
2011	16	8.3%
2010	14	7.3%
2009	18	9.3%

Set name
Text

Distinct	189
Distinct (%)	97.9%
Missing	0
Missing (%)	0.0%
Memory size	1.6 KiB

Length

Max length	48
Median length	34
Mean length	20.341969
Min length	5

Characters and Unicode

Total characters	3926
Distinct characters	66
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	185 ?
Unique (%)	95.9%

Sample

1st row	Grand Soccer Stadium
2nd row	Krusty Krab
3rd row	Captain's Cabin
4th row	Jabba's Prize
5th row	Gryffindor House

Value	Count	Frequency (%)
battle	18	3.1%
starfighter	17	2.9%
the	15	2.6%
pack	13	2.2%
droid	13	2.2%
clone	11	1.9%
fighter	9	1.5%
	9	1.5%
attack	8	1.4%
jedi	8	1.4%
Other values (334)	466	79.4%

Most occurring characters

Value	Count	Frequency (%)
	394	10.0%
e	357	9.1%
a	307	7.8%
r	292	7.4%
t	257	6.5%
o	223	5.7%
i	215	5.5%
n	181	4.6%
l	134	3.4%
s	117	3.0%
Other values (56)	1449	36.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2829	72.1%
Uppercase Letter	602	15.3%
Space Separator	394	10.0%
Other Punctuation	42	1.1%
Dash Punctuation	27	0.7%
Decimal Number	26	0.7%
Open Punctuation	3	0.1%
Close Punctuation	3	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	357	12.6%
a	307	10.9%
r	292	10.3%
t	257	9.1%
o	223	7.9%
i	215	7.6%
n	181	6.4%
l	134	4.7%
s	117	4.1%
d	95	3.4%
Other values (14)	651	23.0%

Uppercase Letter

Value	Count	Frequency (%)
T	66	11.0%
C	64	10.6%
S	60	10.0%
D	44	7.3%
A	43	7.1%
B	40	6.6%
G	28	4.7%
E	27	4.5%
P	27	4.5%
F	26	4.3%
Other values (14)	177	29.4%

Decimal Number

Value	Count	Frequency (%)
1	8	30.8%
0	6	23.1%
3	3	11.5%
2	2	7.7%
5	2	7.7%
4	2	7.7%
6	1	3.8%
7	1	3.8%
9	1	3.8%

Other Punctuation

Value	Count	Frequency (%)
'	28	66.7%
&	9	21.4%
:	3	7.1%
.	1	2.4%
,	1	2.4%

Space Separator

Value	Count	Frequency (%)
	394	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	27	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3431	87.4%
Common	495	12.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	357	10.4%
a	307	8.9%
r	292	8.5%
t	257	7.5%
o	223	6.5%
i	215	6.3%
n	181	5.3%
l	134	3.9%
s	117	3.4%
d	95	2.8%
Other values (38)	1253	36.5%

Common

Value	Count	Frequency (%)
	394	79.6%
'	28	5.7%
-	27	5.5%
&	9	1.8%
1	8	1.6%
0	6	1.2%
(	3	0.6%
)	3	0.6%
3	3	0.6%
:	3	0.6%
Other values (8)	11	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3926	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	394	10.0%
e	357	9.1%
a	307	7.8%
r	292	7.4%
t	257	6.5%
o	223	5.7%
i	215	5.5%
n	181	4.6%
l	134	3.4%
s	117	3.0%
Other values (56)	1449	36.9%

Minifigs
Real number (ℝ)

MISSING

Distinct	13
Distinct (%)	7.3%
Missing	15
Missing (%)	7.8%
Infinite	0
Infinite (%)	0.0%
Mean	3.8539326

Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	9
Maximum	21
Range	20
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.0011318
Coefficient of variation (CV)	0.77871934
Kurtosis	11.514084
Mean	3.8539326
Median Absolute Deviation (MAD)	1
Skewness	2.7068432
Sum	686
Variance	9.0067924
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
4	38	19.7%
1	34	17.6%
3	32	16.6%
2	27	14.0%
5	17	8.8%
6	9	4.7%
8	6	3.1%
9	5	2.6%
7	4	2.1%
21	2	1.0%
Other values (3)	4	2.1%
(Missing)	15	7.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	34	17.6%
2	27	14.0%
3	32	16.6%
4	38	19.7%
5	17	8.8%
6	9	4.7%
7	4	2.1%
8	6	3.1%
9	5	2.6%
10	1	0.5%

Value	Count	Frequency (%)
21	2	1.0%
14	1	0.5%
12	2	1.0%
10	1	0.5%
9	5	2.6%
8	6	3.1%
7	4	2.1%
6	9	4.7%
5	17	8.8%
4	38	19.7%

Pieces
Real number (ℝ)

MISSING

Distinct	161
Distinct (%)	84.7%
Missing	3
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%
Mean	439.82632

Minimum	3
Maximum	7541
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	3
5-th percentile	21.45
Q1	102.5
median	242.5
Q3	451.75
95-th percentile	1070.85
Maximum	7541
Range	7538
Interquartile range (IQR)	349.25

Descriptive statistics

Standard deviation	890.90132
Coefficient of variation (CV)	2.0255753
Kurtosis	43.043223
Mean	439.82632
Median Absolute Deviation (MAD)	154
Skewness	6.2375561
Sum	83567
Variance	793705.16
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
68	3	1.6%
79	3	1.6%
108	2	1.0%
155	2	1.0%
177	2	1.0%
268	2	1.0%
187	2	1.0%
214	2	1.0%
386	2	1.0%
675	2	1.0%
Other values (151)	168	87.0%
(Missing)	3	1.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	1	0.5%
6	1	0.5%
8	2	1.0%
13	1	0.5%
15	1	0.5%
16	1	0.5%
20	1	0.5%
21	2	1.0%
22	2	1.0%
23	1	0.5%

Value	Count	Frequency (%)
7541	1	0.5%
6785	1	0.5%
6187	1	0.5%
3187	1	0.5%
1367	1	0.5%
1330	1	0.5%
1254	1	0.5%
1137	1	0.5%
1111	1	0.5%
1083	1	0.5%

RRP (GBP)
Real number (ℝ)

MISSING

Distinct	65
Distinct (%)	35.5%
Missing	10
Missing (%)	5.2%
Infinite	0
Infinite (%)	0.0%
Mean	42.649781

Minimum	1.99
Maximum	734.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	1.99
5-th percentile	3.49
Q1	9.99
median	24.99
Q3	44.99
95-th percentile	89.99
Maximum	734.99
Range	733
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	88.378945
Coefficient of variation (CV)	2.0722016
Kurtosis	45.35799
Mean	42.649781
Median Absolute Deviation (MAD)	15
Skewness	6.4352642
Sum	7804.91
Variance	7810.8379
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29.99	12	6.2%
14.99	12	6.2%
24.99	12	6.2%
9.99	10	5.2%
59.99	9	4.7%
19.99	7	3.6%
25.99	6	3.1%
8.99	6	3.1%
34.99	5	2.6%
2.99	5	2.6%
Other values (55)	99	51.3%
(Missing)	10	5.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.99	1	0.5%
2.45	1	0.5%
2.49	1	0.5%
2.99	5	2.6%
3.49	3	1.6%
3.89	1	0.5%
3.99	3	1.6%
4.99	3	1.6%
5.99	1	0.5%
6.85	1	0.5%

Value	Count	Frequency (%)
734.99	2	1.0%
519.99	1	0.5%
344.99	1	0.5%
132.99	1	0.5%
129.99	1	0.5%
94.99	1	0.5%
91.99	1	0.5%
89.99	3	1.6%
84.99	2	1.0%
79.99	5	2.6%

RRP (USD)
Real number (ℝ)

MISSING

Distinct	45
Distinct (%)	24.9%
Missing	12
Missing (%)	6.2%
Infinite	0
Infinite (%)	0.0%
Mean	49.952928

Minimum	3.49
Maximum	849.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	3.49
5-th percentile	4.99
Q1	11.99
median	29.99
Q3	49.99
95-th percentile	99.99
Maximum	849.99
Range	846.5
Interquartile range (IQR)	38

Descriptive statistics

Standard deviation	102.69323
Coefficient of variation (CV)	2.0558
Kurtosis	44.791525
Mean	49.952928
Median Absolute Deviation (MAD)	19.99
Skewness	6.3935588
Sum	9041.48
Variance	10545.899
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
19.99	16	8.3%
9.99	16	8.3%
29.99	13	6.7%
24.99	12	6.2%
39.99	11	5.7%
49.99	11	5.7%
30	6	3.1%
10	6	3.1%
69.99	6	3.1%
99.99	6	3.1%
Other values (35)	78	40.4%
(Missing)	12	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.49	4	2.1%
3.99	3	1.6%
4.99	4	2.1%
5	1	0.5%
5.99	1	0.5%
6.99	2	1.0%
7	2	1.0%
9	1	0.5%
9.99	16	8.3%
10	6	3.1%

Value	Count	Frequency (%)
849.99	2	1.0%
599.99	1	0.5%
399.99	1	0.5%
139.99	2	1.0%
129.99	1	0.5%
119.99	1	0.5%
109.99	1	0.5%
99.99	6	3.1%
90	2	1.0%
89.99	5	2.6%

RRP (CAD)
Real number (ℝ)

MISSING

Distinct	31
Distinct (%)	34.1%
Missing	102
Missing (%)	52.8%
Infinite	0
Infinite (%)	0.0%
Mean	88.836154

Minimum	4.99
Maximum	1049.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	4.99
5-th percentile	12.99
Q1	24.99
median	39.99
Q3	82.49
95-th percentile	179.99
Maximum	1049.99
Range	1045
Interquartile range (IQR)	57.5

Descriptive statistics

Standard deviation	173.75826
Coefficient of variation (CV)	1.9559408
Kurtosis	22.168573
Mean	88.836154
Median Absolute Deviation (MAD)	25
Skewness	4.6249967
Sum	8084.09
Variance	30191.932
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
39.99	8	4.1%
34.99	7	3.6%
14.99	7	3.6%
12.99	6	3.1%
24.99	6	3.1%
89.99	5	2.6%
29.99	4	2.1%
49.99	4	2.1%
64.99	4	2.1%
79.99	3	1.6%
Other values (21)	37	19.2%
(Missing)	102	52.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.99	3	1.6%
9.99	1	0.5%
12.99	6	3.1%
13.99	1	0.5%
14.99	7	3.6%
15.99	1	0.5%
19.99	2	1.0%
24.99	6	3.1%
26.99	1	0.5%
29.99	4	2.1%

Value	Count	Frequency (%)
1049.99	2	1.0%
759.99	1	0.5%
499.99	1	0.5%
179.99	2	1.0%
159.99	1	0.5%
139.99	1	0.5%
129.99	3	1.6%
119.99	3	1.6%
99.99	3	1.6%
89.99	5	2.6%

RRP (EUR)
Real number (ℝ)

MISSING

Distinct	20
Distinct (%)	51.3%
Missing	154
Missing (%)	79.8%
Infinite	0
Infinite (%)	0.0%
Mean	118.29769

Minimum	3.99
Maximum	849.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	3.99
5-th percentile	3.99
Q1	29.99
median	64.99
Q3	89.99
95-th percentile	624.99
Maximum	849.99
Range	846
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	202.79107
Coefficient of variation (CV)	1.7142437
Kurtosis	8.3174889
Mean	118.29769
Median Absolute Deviation (MAD)	30
Skewness	2.9994443
Sum	4613.61
Variance	41124.219
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
69.99	6	3.1%
29.99	4	2.1%
89.99	3	1.6%
34.99	3	1.6%
3.99	3	1.6%
849.99	2	1.0%
19.99	2	1.0%
64.99	2	1.0%
49.99	2	1.0%
99.99	2	1.0%
Other values (10)	10	5.2%
(Missing)	154	79.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.99	3	1.6%
9.99	1	0.5%
19.99	2	1.0%
20.99	1	0.5%
29.99	4	2.1%
34.99	3	1.6%
37.99	1	0.5%
49.99	2	1.0%
52.99	1	0.5%
59.99	1	0.5%

Value	Count	Frequency (%)
849.99	2	1.0%
599.99	1	0.5%
399.99	1	0.5%
149.99	1	0.5%
104.99	1	0.5%
99.99	2	1.0%
89.99	3	1.6%
79.99	1	0.5%
69.99	6	3.1%
64.99	2	1.0%

EAN
Real number (ℝ)

MISSING

Distinct	154
Distinct (%)	100.0%
Missing	39
Missing (%)	20.2%
Infinite	0
Infinite (%)	0.0%
Mean	5.7020152 × 10¹²

Minimum	5.702012 × 10¹²
Maximum	5.7020176 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	5.702012 × 10¹²
5-th percentile	5.7020144 × 10¹²
Q1	5.7020145 × 10¹²
median	5.7020145 × 10¹²
Q3	5.7020148 × 10¹²
95-th percentile	5.7020174 × 10¹²
Maximum	5.7020176 × 10¹²
Range	5566322
Interquartile range (IQR)	342358.5

Descriptive statistics

Standard deviation	1159685.5
Coefficient of variation (CV)	2.0338169 × 10^-7
Kurtosis	-0.13195876
Mean	5.7020152 × 10¹²
Median Absolute Deviation (MAD)	112470.5
Skewness	1.0684064
Sum	8.7811033 × 10¹⁴
Variance	1.3448704 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.702014366 × 10¹²	1	0.5%
5.702014601 × 10¹²	1	0.5%
5.702014601 × 10¹²	1	0.5%
5.702014601 × 10¹²	1	0.5%
5.702014601 × 10¹²	1	0.5%
5.702014519 × 10¹²	1	0.5%
5.702014519 × 10¹²	1	0.5%
5.702014368 × 10¹²	1	0.5%
5.702014517 × 10¹²	1	0.5%
5.702014841 × 10¹²	1	0.5%
Other values (144)	144	74.6%
(Missing)	39	20.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.702012018 × 10¹²	1	0.5%
5.702014152 × 10¹²	1	0.5%
5.702014152 × 10¹²	1	0.5%
5.702014152 × 10¹²	1	0.5%
5.702014259 × 10¹²	1	0.5%
5.702014262 × 10¹²	1	0.5%
5.702014364 × 10¹²	1	0.5%
5.702014365 × 10¹²	1	0.5%
5.702014365 × 10¹²	1	0.5%
5.702014366 × 10¹²	1	0.5%

Value	Count	Frequency (%)
5.702017584 × 10¹²	1	0.5%
5.702017498 × 10¹²	1	0.5%
5.702017434 × 10¹²	1	0.5%
5.702017434 × 10¹²	1	0.5%
5.702017421 × 10¹²	1	0.5%
5.702017421 × 10¹²	1	0.5%
5.702017421 × 10¹²	1	0.5%
5.702017421 × 10¹²	1	0.5%
5.702017421 × 10¹²	1	0.5%
5.702017421 × 10¹²	1	0.5%

UPC
Real number (ℝ)

MISSING

Distinct	168
Distinct (%)	100.0%
Missing	25
Missing (%)	13.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.6966597 × 10¹¹

Minimum	4.2884047 × 10¹⁰
Maximum	6.7341939 × 10¹¹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	4.2884047 × 10¹⁰
5-th percentile	6.7341904 × 10¹¹
Q1	6.7341909 × 10¹¹
median	6.7341911 × 10¹¹
Q3	6.7341916 × 10¹¹
95-th percentile	6.7341938 × 10¹¹
Maximum	6.7341939 × 10¹¹
Range	6.3053534 × 10¹¹
Interquartile range (IQR)	66450

Descriptive statistics

Standard deviation	4.8646839 × 10¹⁰
Coefficient of variation (CV)	0.07264344
Kurtosis	168
Mean	6.6966597 × 10¹¹
Median Absolute Deviation (MAD)	32770.5
Skewness	-12.961481
Sum	1.1250388 × 10¹⁴
Variance	2.366515 × 10²¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.734190728 × 10¹¹	1	0.5%
6.734191291 × 10¹¹	1	0.5%
6.734191288 × 10¹¹	1	0.5%
6.734191298 × 10¹¹	1	0.5%
6.734191298 × 10¹¹	1	0.5%
6.73419129 × 10¹¹	1	0.5%
6.73419129 × 10¹¹	1	0.5%
6.73419129 × 10¹¹	1	0.5%
6.73419129 × 10¹¹	1	0.5%
6.734191291 × 10¹¹	1	0.5%
Other values (158)	158	81.9%
(Missing)	25	13.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.288404722 × 10¹⁰	1	0.5%
6.734190102 × 10¹¹	1	0.5%
6.734190102 × 10¹¹	1	0.5%
6.734190103 × 10¹¹	1	0.5%
6.734190336 × 10¹¹	1	0.5%
6.734190338 × 10¹¹	1	0.5%
6.734190338 × 10¹¹	1	0.5%
6.734190343 × 10¹¹	1	0.5%
6.734190348 × 10¹¹	1	0.5%
6.734190363 × 10¹¹	1	0.5%

Value	Count	Frequency (%)
6.734193895 × 10¹¹	1	0.5%
6.734193842 × 10¹¹	1	0.5%
6.73419379 × 10¹¹	1	0.5%
6.73419379 × 10¹¹	1	0.5%
6.73419377 × 10¹¹	1	0.5%
6.73419377 × 10¹¹	1	0.5%
6.73419377 × 10¹¹	1	0.5%
6.734193769 × 10¹¹	1	0.5%
6.734193769 × 10¹¹	1	0.5%
6.734193769 × 10¹¹	1	0.5%

Width
Real number (ℝ)

MISSING

Distinct	34
Distinct (%)	18.5%
Missing	9
Missing (%)	4.7%
Infinite	0
Infinite (%)	0.0%
Mean	31.702337

Minimum	9.4
Maximum	65.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	9.4
5-th percentile	12.706
Q1	19.1
median	28.8
Q3	38.4
95-th percentile	58.11
Maximum	65.2
Range	55.8
Interquartile range (IQR)	19.3

Descriptive statistics

Standard deviation	14.187101
Coefficient of variation (CV)	0.44750964
Kurtosis	-0.53764881
Mean	31.702337
Median Absolute Deviation (MAD)	9.6
Skewness	0.4805422
Sum	5833.23
Variance	201.27385
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
19.1	21	10.9%
38.2	19	9.8%
48	18	9.3%
28.8	14	7.3%
38.4	13	6.7%
19.2	10	5.2%
26.2	9	4.7%
14.4	9	4.7%
24	9	4.7%
28.19	7	3.6%
Other values (24)	55	28.5%
(Missing)	9	4.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.4	5	2.6%
9.5	2	1.0%
9.6	2	1.0%
12.46	1	0.5%
14.1	5	2.6%
14.4	9	4.7%
15.7	1	0.5%
19	1	0.5%
19.1	21	10.9%
19.2	10	5.2%

Value	Count	Frequency (%)
65.2	6	3.1%
58.2	4	2.1%
57.6	3	1.6%
54	2	1.0%
53.3	1	0.5%
52.3	1	0.5%
49.9	1	0.5%
48.01	3	1.6%
48	18	9.3%
43.2	3	1.6%

Height
Real number (ℝ)

MISSING

Distinct	22
Distinct (%)	12.0%
Missing	9
Missing (%)	4.7%
Infinite	0
Infinite (%)	0.0%
Mean	24.225326

Minimum	9.09
Maximum	49.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	9.09
5-th percentile	12.4765
Q1	14.4
median	26.2
Q3	28.8
95-th percentile	38.4
Maximum	49.9
Range	40.81
Interquartile range (IQR)	14.4

Descriptive statistics

Standard deviation	8.9318639
Coefficient of variation (CV)	0.36869943
Kurtosis	-0.34450744
Mean	24.225326
Median Absolute Deviation (MAD)	7.1
Skewness	0.35565578
Sum	4457.46
Variance	79.778193
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
28.8	36	18.7%
26.2	25	13.0%
14.4	22	11.4%
14.1	17	8.8%
19.1	16	8.3%
38.4	11	5.7%
19.2	11	5.7%
35.4	8	4.1%
26.19	8	4.1%
28.2	6	3.1%
Other values (12)	24	12.4%
(Missing)	9	4.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.09	3	1.6%
9.1	1	0.5%
9.6	4	2.1%
10.6	1	0.5%
12.19	1	0.5%
14.1	17	8.8%
14.4	22	11.4%
15	2	1.0%
19.1	16	8.3%
19.2	11	5.7%

Value	Count	Frequency (%)
49.9	1	0.5%
48	2	1.0%
46	1	0.5%
43.2	1	0.5%
38.4	11	5.7%
37.8	5	2.6%
35.4	8	4.1%
28.8	36	18.7%
28.2	6	3.1%
28.19	2	1.0%

Depth
Real number (ℝ)

MISSING

Distinct	39
Distinct (%)	21.2%
Missing	9
Missing (%)	4.7%
Infinite	0
Infinite (%)	0.0%
Mean	6.6719022

Minimum	0.7
Maximum	38.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0.7
5-th percentile	4.515
Q1	4.8
median	6
Q3	7.2
95-th percentile	9.6
Maximum	38.5
Range	37.8
Interquartile range (IQR)	2.4

Descriptive statistics

Standard deviation	4.0000189
Coefficient of variation (CV)	0.599532
Kurtosis	42.644795
Mean	6.6719022
Median Absolute Deviation (MAD)	1.2
Skewness	5.8466333
Sum	1227.63
Variance	16.000151
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
6	28	14.5%
4.6	26	13.5%
4.8	26	13.5%
7.2	17	8.8%
6.1	11	5.7%
7.1	11	5.7%
9.6	10	5.2%
5.7	5	2.6%
6.4	5	2.6%
8.79	3	1.6%
Other values (29)	42	21.8%
(Missing)	9	4.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.7	2	1.0%
2.8	1	0.5%
3.9	1	0.5%
4.04	3	1.6%
4.05	1	0.5%
4.4	1	0.5%
4.5	1	0.5%
4.6	26	13.5%
4.7	2	1.0%
4.8	26	13.5%

Value	Count	Frequency (%)
38.5	1	0.5%
37.9	1	0.5%
23.8	1	0.5%
12.4	1	0.5%
11.8	2	1.0%
11.4	2	1.0%
9.6	10	5.2%
9.4	1	0.5%
9.1	3	1.6%
9	1	0.5%

Weight
Real number (ℝ)

MISSING

Distinct	71
Distinct (%)	59.2%
Missing	73
Missing (%)	37.8%
Infinite	0
Infinite (%)	0.0%
Mean	0.58264167

Minimum	0.03
Maximum	2.63
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0.03
5-th percentile	0.078
Q1	0.14
median	0.37
Q3	0.78
95-th percentile	2.128
Maximum	2.63
Range	2.6
Interquartile range (IQR)	0.64

Descriptive statistics

Standard deviation	0.60296558
Coefficient of variation (CV)	1.0348824
Kurtosis	2.9039543
Mean	0.58264167
Median Absolute Deviation (MAD)	0.26
Skewness	1.8142323
Sum	69.917
Variance	0.36356749
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.11	6	3.1%
0.03	5	2.6%
0.34	4	2.1%
0.78	4	2.1%
0.1	4	2.1%
0.12	4	2.1%
0.09	4	2.1%
0.14	3	1.6%
0.44	3	1.6%
0.19	3	1.6%
Other values (61)	80	41.5%
(Missing)	73	37.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.03	5	2.6%
0.04	1	0.5%
0.08	2	1.0%
0.09	4	2.1%
0.1	4	2.1%
0.11	6	3.1%
0.12	4	2.1%
0.13	3	1.6%
0.14	3	1.6%
0.15	3	1.6%

Value	Count	Frequency (%)
2.63	1	0.5%
2.45	2	1.0%
2.38	1	0.5%
2.33	1	0.5%
2.28	1	0.5%
2.12	1	0.5%
2.04	1	0.5%
1.88	1	0.5%
1.75	1	0.5%
1.54	1	0.5%

Notes
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	193
Missing (%)	100.0%
Memory size	1.6 KiB

Qty owned
Categorical

IMBALANCE

Distinct	4
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 KiB

1	188
2	3
7	1
4	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	193
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	1.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	188	97.4%
2	3	1.6%
7	1	0.5%
4	1	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	188	97.4%
2	3	1.6%
7	1	0.5%
4	1	0.5%

Most occurring characters

Value	Count	Frequency (%)
1	188	97.4%
2	3	1.6%
7	1	0.5%
4	1	0.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	193	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	188	97.4%
2	3	1.6%
7	1	0.5%
4	1	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	193	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	188	97.4%
2	3	1.6%
7	1	0.5%
4	1	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	193	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	188	97.4%
2	3	1.6%
7	1	0.5%
4	1	0.5%

Qty owned new
Categorical

IMBALANCE

Distinct	4
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 KiB

1	188
2	3
7	1
4	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	193
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	1.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	188	97.4%
2	3	1.6%
7	1	0.5%
4	1	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	188	97.4%
2	3	1.6%
7	1	0.5%
4	1	0.5%

Most occurring characters

Value	Count	Frequency (%)
1	188	97.4%
2	3	1.6%
7	1	0.5%
4	1	0.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	193	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	188	97.4%
2	3	1.6%
7	1	0.5%
4	1	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	193	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	188	97.4%
2	3	1.6%
7	1	0.5%
4	1	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	193	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	188	97.4%
2	3	1.6%
7	1	0.5%
4	1	0.5%

Qty owned used
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	1.6 KiB

0	193

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	193
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	193	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	193	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	193	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	193	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	193	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	193	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	193	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	193	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	193	100.0%

Wanted
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	193
Missing (%)	100.0%
Memory size	1.6 KiB

Qty wanted
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	1.6 KiB

0	193

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	193
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	193	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	193	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	193	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	193	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	193	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	193	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	193	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	193	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	193	100.0%

Priority
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	1.6 KiB

1	193

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	193
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	193	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	193	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	193	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	193	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	193	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	193	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	193	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	193	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	193	100.0%

Flag 1 not used
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	193
Missing (%)	100.0%
Memory size	1.6 KiB

Flag 2 not used
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	193
Missing (%)	100.0%
Memory size	1.6 KiB

Flag 3 not used
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	193
Missing (%)	100.0%
Memory size	1.6 KiB

Flag 4 not used
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	193
Missing (%)	100.0%
Memory size	1.6 KiB

Flag 5 not used
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	193
Missing (%)	100.0%
Memory size	1.6 KiB

Flag 6 not used
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	193
Missing (%)	100.0%
Memory size	1.6 KiB

Flag 7 not used
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	193
Missing (%)	100.0%
Memory size	1.6 KiB

Flag 8 not used
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	193
Missing (%)	100.0%
Memory size	1.6 KiB

Value new (USD)
Real number (ℝ)

MISSING

Distinct	190
Distinct (%)	99.5%
Missing	2
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	134.64372

Minimum	2.8
Maximum	863.65
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	2.8
5-th percentile	9.735
Q1	41.55
median	79.95
Q3	156.06
95-th percentile	463.235
Maximum	863.65
Range	860.85
Interquartile range (IQR)	114.51

Descriptive statistics

Standard deviation	153.92111
Coefficient of variation (CV)	1.1431733
Kurtosis	6.0153331
Mean	134.64372
Median Absolute Deviation (MAD)	44.85
Skewness	2.3544882
Sum	25716.95
Variance	23691.707
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
81.54	2	1.0%
259.43	1	0.5%
50.72	1	0.5%
79.95	1	0.5%
142.35	1	0.5%
39.53	1	0.5%
155.96	1	0.5%
112.05	1	0.5%
124.36	1	0.5%
9.54	1	0.5%
Other values (180)	180	93.3%
(Missing)	2	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.8	1	0.5%
3.73	1	0.5%
4.09	1	0.5%
5.33	1	0.5%
6.32	1	0.5%
6.73	1	0.5%
6.97	1	0.5%
7.1	1	0.5%
8.57	1	0.5%
9.54	1	0.5%

Value	Count	Frequency (%)
863.65	1	0.5%
752.52	1	0.5%
747.81	1	0.5%
679.79	1	0.5%
663.99	1	0.5%
639.84	1	0.5%
505.02	1	0.5%
500	1	0.5%
481	1	0.5%
463.63	1	0.5%

Value used (USD)
Real number (ℝ)

MISSING

Distinct	183
Distinct (%)	99.5%
Missing	9
Missing (%)	4.7%
Infinite	0
Infinite (%)	0.0%
Mean	68.494185

Minimum	2.04
Maximum	617.34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	2.04
5-th percentile	8.1435
Q1	23.1175
median	40.745
Q3	74.03
95-th percentile	213.023
Maximum	617.34
Range	615.3
Interquartile range (IQR)	50.9125

Descriptive statistics

Standard deviation	85.669044
Coefficient of variation (CV)	1.2507492
Kurtosis	16.508412
Mean	68.494185
Median Absolute Deviation (MAD)	21.75
Skewness	3.5204213
Sum	12602.93
Variance	7339.1852
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.32	2	1.0%
153.34	1	0.5%
5.22	1	0.5%
2.3	1	0.5%
2.04	1	0.5%
13.41	1	0.5%
12.82	1	0.5%
21.15	1	0.5%
31.07	1	0.5%
69.92	1	0.5%
Other values (173)	173	89.6%
(Missing)	9	4.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.04	1	0.5%
2.3	1	0.5%
2.45	1	0.5%
3.36	1	0.5%
4.8	1	0.5%
5.22	1	0.5%
5.53	1	0.5%
5.94	1	0.5%
7.36	1	0.5%
8.13	1	0.5%

Value	Count	Frequency (%)
617.34	1	0.5%
576	1	0.5%
420.45	1	0.5%
325.43	1	0.5%
300.61	1	0.5%
269.42	1	0.5%
250	1	0.5%
233.99	1	0.5%
227.54	1	0.5%
214.13	1	0.5%

Launch date
Date

MISSING

Distinct	62
Distinct (%)	35.2%
Missing	17
Missing (%)	8.8%
Memory size	1.6 KiB

Minimum	2001-01-09 00:00:00
Maximum	2024-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Exit date
Categorical

MISSING

Distinct	31
Distinct (%)	17.6%
Missing	17
Missing (%)	8.8%
Memory size	1.6 KiB

31/12/2009	17
31/12/2010	15
31/12/2012	15
31/12/2008	14
31/12/2024	13
Other values (26)	102

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1760
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	5.1%

Sample

1st row	31/12/2007
2nd row	31/12/2007
3rd row	31/12/2012
4th row	31/12/2003
5th row	31/12/2002

Common Values

Value	Count	Frequency (%)
31/12/2009	17	8.8%
31/12/2010	15	7.8%
31/12/2012	15	7.8%
31/12/2008	14	7.3%
31/12/2024	13	6.7%
31/12/2011	11	5.7%
31/12/2006	10	5.2%
31/12/2025	9	4.7%
31/12/2005	9	4.7%
31/12/2023	8	4.1%
Other values (21)	55	28.5%
(Missing)	17	8.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
31/12/2009	17	9.7%
31/12/2012	15	8.5%
31/12/2010	15	8.5%
31/12/2008	14	8.0%
31/12/2024	13	7.4%
31/12/2011	11	6.2%
31/12/2006	10	5.7%
31/12/2025	9	5.1%
31/12/2005	9	5.1%
31/12/2023	8	4.5%
Other values (21)	55	31.2%

Most occurring characters

Value	Count	Frequency (%)
2	396	22.5%
1	392	22.3%
/	352	20.0%
0	303	17.2%
3	193	11.0%
7	27	1.5%
4	22	1.2%
9	20	1.1%
8	20	1.1%
5	19	1.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1408	80.0%
Other Punctuation	352	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	396	28.1%
1	392	27.8%
0	303	21.5%
3	193	13.7%
7	27	1.9%
4	22	1.6%
9	20	1.4%
8	20	1.4%
5	19	1.3%
6	16	1.1%

Other Punctuation

Value	Count	Frequency (%)
/	352	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1760	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	396	22.5%
1	392	22.3%
/	352	20.0%
0	303	17.2%
3	193	11.0%
7	27	1.5%
4	22	1.2%
9	20	1.1%
8	20	1.1%
5	19	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1760	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	396	22.5%
1	392	22.3%
/	352	20.0%
0	303	17.2%
3	193	11.0%
7	27	1.5%
4	22	1.2%
9	20	1.1%
8	20	1.1%
5	19	1.1%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Number	Theme	Subtheme	Year	Set name	Minifigs	Pieces	RRP (GBP)	RRP (USD)	RRP (CAD)	RRP (EUR)	EAN	UPC	Width	Height	Depth	Weight	Notes	Qty owned	Qty owned new	Wanted	Priority	Flag 1 not used	Flag 2 not used	Flag 3 not used	Flag 4 not used	Flag 5 not used	Flag 6 not used	Flag 7 not used	Flag 8 not used	Value new (USD)	Value used (USD)	Launch date	Exit date
0	3569-1	Sports	Football	2006	Grand Soccer Stadium	14.0	386.0	29.99	49.99	NaN	NaN	NaN	6.734191e+11	58.2	38.4	7.5	1.75	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	259.43	153.34	01/01/2006	31/12/2007
1	3825-1	SpongeBob SquarePants	NaN	2006	Krusty Krab	3.0	295.0	19.99	19.99	NaN	NaN	NaN	6.734191e+11	28.8	28.8	4.8	0.49	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	232.13	98.65	01/06/2006	31/12/2007
2	4191-1	Pirates of the Caribbean	On Stranger Tides	2011	Captain's Cabin	3.0	95.0	10.49	11.99	14.99	NaN	5.702015e+12	6.734192e+11	19.1	14.1	4.6	0.13	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	46.48	31.87	01/05/2011	31/12/2012
3	4476-1	Star Wars	Episode VI	2003	Jabba's Prize	2.0	40.0	5.99	7.00	NaN	NaN	5.702014e+12	NaN	14.4	14.4	3.9	NaN	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	184.70	50.17	01/01/2003	31/12/2003
4	4722-1	Harry Potter	Philosopher's Stone	2001	Gryffindor House	1.0	68.0	8.99	10.00	NaN	NaN	5.702012e+12	4.288405e+10	19.2	19.2	4.8	NaN	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	57.50	34.72	01/09/2001	31/12/2002
5	4754-1	Harry Potter	Prisoner of Azkaban	2004	Hagrid's Hut	2.0	302.0	19.99	30.00	NaN	NaN	5.702014e+12	6.734190e+11	28.8	28.8	6.0	0.58	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	121.26	44.70	05/04/2004	31/12/2005
6	4757-1	Harry Potter	Prisoner of Azkaban	2004	Hogwarts Castle	9.0	944.0	79.99	90.00	NaN	NaN	5.702014e+12	6.734190e+11	57.6	38.4	9.6	2.12	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	463.63	190.48	05/04/2004	31/12/2005
7	4758-1	Harry Potter	Prisoner of Azkaban	2004	Hogwarts Express	4.0	389.0	34.99	40.00	NaN	NaN	5.702014e+12	6.734190e+11	33.6	28.8	7.2	0.79	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	223.43	120.69	05/04/2004	31/12/2005
8	4762-1	Harry Potter	Goblet of Fire	2005	Rescue from the Merpeople	5.0	175.0	14.99	20.00	NaN	NaN	5.702014e+12	6.734191e+11	19.2	28.8	4.8	0.30	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	240.00	103.58	01/10/2005	31/07/2006
9	4766-1	Harry Potter	Goblet of Fire	2005	Graveyard Duel	6.0	548.0	29.99	30.00	NaN	NaN	5.702014e+12	6.734191e+11	38.4	28.8	6.0	0.80	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	365.59	162.27	01/10/2005	31/07/2006

	Number	Theme	Subtheme	Year	Set name	Minifigs	Pieces	RRP (GBP)	RRP (USD)	RRP (CAD)	RRP (EUR)	EAN	UPC	Width	Height	Depth	Weight	Notes	Qty owned	Qty owned new	Wanted	Priority	Flag 1 not used	Flag 2 not used	Flag 3 not used	Flag 4 not used	Flag 5 not used	Flag 6 not used	Flag 7 not used	Flag 8 not used	Value new (USD)	Value used (USD)	Launch date	Exit date
183	76191-1	Marvel Super Heroes	Miscellaneous	2021	Infinity Gauntlet	NaN	590.0	79.99	79.99	99.99	89.99	5.702017e+12	6.734193e+11	19.1	35.4	9.1	NaN	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	51.81	39.44	01/06/2021	31/12/2025
184	76212-1	Marvel Super Heroes	Black Panther	2022	Shuri's Lab	2.0	58.0	8.99	9.99	13.99	9.99	5.702017e+12	6.734194e+11	15.7	14.1	4.5	NaN	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6.73	NaN	01/10/2022	31/12/2023
185	76217-1	Marvel Super Heroes	Guardians of the Galaxy Vol. 2	2022	I am Groot	NaN	476.0	44.99	54.99	69.99	49.99	5.702017e+12	6.734194e+11	19.1	35.4	7.0	NaN	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	31.49	26.40	01/06/2022	31/12/2024
186	76223-1	Marvel Super Heroes	Avengers: Endgame	2022	Nano Gauntlet	NaN	675.0	59.99	69.99	89.99	69.99	5.702017e+12	6.734194e+11	19.1	35.4	9.1	NaN	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	71.47	49.00	01/08/2022	31/12/2025
187	76231-1	Marvel Super Heroes	Seasonal	2022	Guardians of the Galaxy Advent Calendar	6.0	268.0	29.99	44.99	59.99	34.99	5.702017e+12	NaN	38.2	26.2	7.1	NaN	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	30.33	20.08	01/09/2022	31/12/2022
188	76249-1	Marvel Super Heroes	Miscellaneous	2023	Venomized Groot	NaN	630.0	46.99	49.99	64.99	52.99	5.702017e+12	6.734194e+11	19.1	35.4	7.0	NaN	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	46.96	NaN	01/08/2023	31/12/2024
189	912302-1	Star Wars	Magazine Gift	2023	Bo-Katan Kryze	1.0	8.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8.57	8.72	NaN	NaN
190	912310-1	Star Wars	Magazine Gift	2023	C-3PO & Gonk Droid	2.0	15.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6.97	NaN	NaN	NaN
191	4293136-1	Dino 2010	NaN	2006	Parachute and Minifigure	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	1	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
192	5000063-1	Star Wars	Episode I	2012	TC-14	1.0	3.0	NaN	NaN	NaN	NaN	NaN	6.734192e+11	NaN	NaN	NaN	NaN	NaN	4	4	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	120.69	137.99	NaN	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values